
/*
{
"状态":1,
"名称":"删除-款图片地址",
"作者":"",
"创建时间":"2018-12-25",
"功能":"删除-款图片地址",
"log": [
	{"date":"" , "dev" :"" , "content" : ""}
]
}
*/
DECLARE @styleno varchar(100)
DECLARE @colorid varchar(10)

Set @styleno='{styleno}'
Set @colorid='{colorid}'

if isnull(@colorid,'')=''
begin
	DELETE FROM [r_style_pic] WHERE  styleno=@styleno  
end
else
begin
	DELETE FROM [r_style_pic] WHERE  styleno=@styleno And colorid=@colorid
end